<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UC_Gift_Selection_Report.aspx.cs"
    Inherits="UpperCrust_UC_Gift_Selection_Report" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Upper Crust Gift Selection View</title>
    <link href="../Style/layout1_setup.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="scriptmgr" runat="server">
    </asp:ScriptManager>
    <div style="font-weight: bold">
        <h1 style="font-size: medium; color: #5070AB;">
            UC Gift Selection Report
        </h1>
    </div>
    <div>
        <asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1"
            DisplayAfter="0">
            <ProgressTemplate>
                <asp:Label ID="Label6" runat="server" Text="Please Wait....." ForeColor="Red"></asp:Label>
                <asp:Image ID="Image1" runat="server" ImageUrl="~/Images2/remembermilk_orange.gif"
                    Visible="true"></asp:Image>
            </ProgressTemplate>
        </asp:UpdateProgress>
    </div>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <div class="dbmain">
                <div class="sttable4">
                    <table border="0">
                        <tr>
                            <td colspan="2">
                                <asp:HiddenField ID="hdnUCFor" runat="server" />
                                <asp:Label ID="lblMsg" runat="server" ForeColor="#FF3300"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td align="right" style="width: 50%">
                                <b>UC For:</b>
                            </td>
                            <td>
                                <asp:DropDownList ID="ddlUCFor" runat="server" CssClass="dtext" OnSelectedIndexChanged="ddlUCFor_SelectedIndexChanged"
                                    AutoPostBack="true">
                                    <asp:ListItem Value="-1" Text="---Select---"></asp:ListItem>
                                    <asp:ListItem Value="1" Text="FMV"></asp:ListItem>
                                    <asp:ListItem Value="2" Text="RMV"></asp:ListItem>
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr id="trZM" runat="server">
                            <td align="right" style="width: 50%">
                                <b>ZM:</b>
                            </td>
                            <td>
                                <asp:DropDownList ID="ddlZM" runat="server" CssClass="dtext" AutoPostBack="true"
                                    Width="170px" OnSelectedIndexChanged="ddlZM_SelectedIndexChanged">
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr id="trRM" runat="server">
                            <td align="right" style="width: 50%">
                                <asp:RequiredFieldValidator ID="rfRM" runat="server" ControlToValidate="ddlRM" ErrorMessage="Please Select RM"
                                    Display="Dynamic" InitialValue="-1" ValidationGroup="valGrp" Text="Please Select RM">*</asp:RequiredFieldValidator>
                                <b>RM:</b>
                            </td>
                            <td>
                                <%--     <asp:DropDownList ID="ddlRegion" runat="server" CssClass="dtext" AutoPostBack="true"
                                    Width="170px">
                                </asp:DropDownList>--%>
                                <asp:DropDownList ID="ddlRM" runat="server" CssClass="dtext" AutoPostBack="true"
                                    Width="170px" OnSelectedIndexChanged="ddlRM_SelectedIndexChanged">
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr id="trFM" runat="server">
                            <td align="right">
                                <b>FM:</b>
                            </td>
                            <td>
                                <asp:DropDownList ID="ddlFM" runat="server" CssClass="dtext" AutoPostBack="true"
                                    Width="170px" OnSelectedIndexChanged="ddlFM_SelectedIndexChanged">
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr id="trGift" runat="server">
                            <td align="right">
                                <b>Select Gift:</b>
                            </td>
                            <td>
                                <asp:DropDownList ID="ddlGift" runat="server" CssClass="dtext" Width="170px">
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr>
                            <td align="center" colspan="2">
                                <asp:Button ID="btnGo" runat="server" CssClass="btext" Text="Go" Width="80px" ValidationGroup="valGrp"
                                    OnClick="btnGo_Click" />
                            </td>
                        </tr>
                    </table>
                    <table border="0">
                        <tr>
                            <td>
                                <asp:GridView ID="GridView1" runat="server" CssClass="grd_style" AutoGenerateColumns="False">
                                    <Columns>
                                        <asp:BoundField DataField="uc_for" HeaderText="UC For" />
                                        <asp:BoundField DataField="Rm_Name" HeaderText="RM Name" />
                                        <asp:BoundField DataField="RM_DIV" HeaderText="RM Div" />
                                        <asp:BoundField DataField="DM_NAME" HeaderText="FM Name" />
                                        <asp:BoundField DataField="DOC_ID" HeaderText="Doctor ID" />
                                        <asp:BoundField DataField="DOC_name" HeaderText="Doctor Name" />
                                        <asp:BoundField DataField="DOC_CITY" HeaderText="Doctor City" />
                                        <asp:BoundField DataField="spec" HeaderText="Specaility" />
                                        <asp:BoundField DataField="cls" HeaderText="Class" />
                                        <asp:BoundField DataField="cls" HeaderText="Q3 Gift Name" />
                                        <asp:BoundField DataField="cls" HeaderText="Q4 Gift Name" />
                                    </Columns>
                                    <RowStyle CssClass="row_style" />
                                    <AlternatingRowStyle BackColor="White" />
                                    <SelectedRowStyle CssClass="selected_row_style" />
                                    <FooterStyle CssClass="footer_style" />
                                    <PagerStyle CssClass="pager_style" />
                                    <HeaderStyle CssClass="header_style" />
                                    <EditRowStyle CssClass="edit_style" />
                                </asp:GridView>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                &nbsp;
                                <asp:Button ID="btnExport" runat="server" CssClass="btext" 
                                    OnClick="btnExport_Click" Text="Export to Excel" />
                            </td>
                        </tr>
                    </table>
                  
                </div>
            </div>
        </ContentTemplate>
    </asp:UpdatePanel>
      <table width="100%" border="0" cellpadding="1" cellspacing="1" align="center">
                        <tr>
                            <td align=center>
                                &nbsp;</td>
                        </tr>
                    </table>
    </form>
</body>
</html>



 protected void btnExport_Click(object sender, EventArgs e)
    {

        if (GridView1.Rows.Count > 0)
        {
            if (RenderGridToExcelFormat_New())
            {

                lblMsg.Text = "Records exported successfully";
              
            }
        }

        else
        {
            lblMsg.Text = "No Records to Export";
      

        }
            

    }


    public bool RenderGridToExcelFormat_New()
    {

        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
        Response.Charset = "";

        this.EnableViewState = false;

        GridView1.AllowSorting = false;
        GridView1.AllowPaging = false;

        // If you want the option to open the Excel file without saving then
        // comment out the line below
        // Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

        GridView1.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
        return true;

    }

    public override void VerifyRenderingInServerForm(Control control)
    {

    } 

   